# Prerequisites

The following section lists the prerequisites for working with Qlik Replicate and an Amazon RDS for PostgreSQL source.

## Client prerequisites

### Replicate for Windows

PostgreSQL ODBC Driver psqlodbc\_17\_xx\_xxxx-x64 must be installed on the Replicate machine.

Information noteMake sure that the psql.exe path (e.g. "C:\Program Files\PostgreSQL\17xx\bin") is added to the system PATH.

### Replicate for Linux

Download PostgreSQL 17 ODBC driver, and client programs and libraries.

* Example PostgreSQL ODBC file name: postgresql17-odbc-17.00.0006-1PGDG.rhel8.x86\_64.rpm
* PostgreSQL client programs and libraries file name: postgresql17-17.00.0006-1PGDG.rhel<version>.x86\_64.rpm

Then, open a shell prompt and do the following:

1. Stop the Replicate service and optionally confirm that it has stopped as described in [Replicate server procedures](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/Installation/Server_Procedures.htm).

2. Install PostgreSQL 17 client programs and libraries.

3. Install the ODBC driver for PostgreSQL 17.

4. Change the working directory to <Replicate-Install-Dir>/bin.

5. Copy the driver location to the `site_arep_login.sh` file:

   `echo "export LD_LIBRARY_PATH=\$LD_LIBRARY_PATH:/usr/lib:/usr/lib64:/usr/pgsql-17/lib" >> site_arep_login.sh`

   This will add the driver to "LD\_LIBRARY\_PATH" and update the driver location in the site\_arep\_login.sh file.

6. Optionally, confirm that the driver location was copied:

   ```
   cat site_arep_login.sh
                           
   ```

7. Makes sure that the `/etc/odbcinst.ini` file contains an entry for PostgreSQL, as in the following example:

   `[PostgreSQL]`

   `Description = PostgreSQL ODBC driver`

   `Driver = /usr/pgsql-17/lib/psqlodbc.so`

   `Setup = /usr/pgsql-17/lib/psqlodbcw.so`

   `UsageCount = 1`

8. Start the Replicate service and optionally confirm that it has started as described in [Replicate server procedures](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/Installation/Server_Procedures.htm).

## Apply changes prerequisites

When the Apply Changes task option is enabled, the user specified in the Amazon RDS for PostgreSQL source endpoint’s **General** tab must be granted super-user permissions.